﻿CREATE TABLE [dbo].[Articulos] (
    [IdArticulo]             INT           IDENTITY (1, 1) NOT NULL,
    [IdTipoArticulo]         TINYINT       NOT NULL,
    [IdRubroArticulo]        INT           NOT NULL,
    [IdDescuentoRecargo]     INT           NOT NULL,
    [IdMarca]                INT           NOT NULL,
    [IdTipoComisionArticulo] TINYINT       NOT NULL,
    [IdTipoImpuestoArticulo] TINYINT       NOT NULL,
    [IdTipoCostoArticulo]    TINYINT       NOT NULL,
    [IdPromocion]            INT           NOT NULL,
    [Codigo]                 VARCHAR (20)  NOT NULL,
    [Nombre]                 VARCHAR (50)  NOT NULL,
    [ExistenciaMinimo]       INT           NOT NULL,
    [ExistenciaMaximo]       INT           NOT NULL,
    [DescripcionServicio]    VARCHAR (200) NOT NULL,
    [Costo]                  MONEY         NOT NULL,
    [Comision]               MONEY         NOT NULL,
    [ComisionMaxima]         MONEY         NOT NULL,
    [Iva]                    MONEY         NOT NULL,
    [Impuesto]               MONEY         NOT NULL,
    [EstaEliminado]          BIT           NOT NULL
);





